fe727cf1a08055fcb5cc75cc4d7eade198b9fc9f,bobas.businessobjectscommon.db.mysql/src/main/java/org/colorcoding/ibas/bobas/db/mysql/SqlScripts.java,SqlScripts,getBOTransactionNotificationScript,#String#String#number#String#String#,114

Before Change


	@Override
	public String getBOTransactionNotificationScript(String boCode, String type, int keyCount, String keyNames,
			String keyValues) throws SqlScriptsException {
		return String.format("CALL `%s_SP_TRANSACTION_NOTIFICATION`( N'%s', N'%s', %s, N'%s', N'%s')",
				this.getCompanyId(), boCode, type, keyCount, keyNames, keyValues);
	}

	@Override

After Change


	@Override
	public String getBOTransactionNotificationScript(String boCode, String type, int keyCount, String keyNames,
			String keyValues) throws SqlScriptsException {
		StringBuilder stringBuilder = new StringBuilder();
		stringBuilder.append("CALL");
		stringBuilder.append(" ");
		stringBuilder.appendFormat("`%s_SP_TRANSACTION_NOTIFICATION`", this.getCompanyId());
		stringBuilder.append("(");
		stringBuilder.append(" ");
		stringBuilder.append("N'");
		stringBuilder.append(boCode);
		stringBuilder.append("'");
		stringBuilder.append(",");
		stringBuilder.append(" ");
		stringBuilder.append("N'");
		stringBuilder.append(type);
		stringBuilder.append("'");
		stringBuilder.append(",");
		stringBuilder.append(" ");
		stringBuilder.append(keyCount);
		stringBuilder.append(",");
		stringBuilder.append(" ");
		stringBuilder.append("N'");
		stringBuilder.append(keyNames);
		stringBuilder.append("'");
		stringBuilder.append(",");
		stringBuilder.append(" ");
		stringBuilder.append("N'");
		stringBuilder.append(keyValues);
		stringBuilder.append("'");
		stringBuilder.append(")");
		return stringBuilder.toString();
	}

	@Override